﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MyMasterPage.master" AutoEventWireup="true" CodeFile="Projects.aspx.cs" Inherits="pages_Projects" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div class="right_side">
			   <div class="nav">
			   <h2>Industrial Proejcts:</h2>
            <ul>
                <asp:SqlDataSource ID="SqlDataSource7" runat="server" ConnectionString="<%$ ConnectionStrings:Personal %>"
                      SelectCommand="SELECT TOP (3) [id], [ProName],REPLACE(ProName, ' ', '-') AS ProTitle, [ProCaption], [ProContent], [ProTechLang], [ProDatabase], [ProType], [ProTools], [ProURL], [ProCatagory] FROM [Projects] WHERE ([ProCatagory] = @ProCatagory) ORDER BY [ProDisplaySerial]">
                      <SelectParameters>
                          <asp:Parameter DefaultValue="ind" Name="ProCatagory" Type="String" />
                      </SelectParameters>
                  </asp:SqlDataSource>
                <asp:Repeater ID="Repeater3" runat="server" DataSourceID="SqlDataSource7">
                    <ItemTemplate>
                        <li>
                            <% string siteDirName = System.Configuration.ConfigurationManager.AppSettings["siteDirName"].ToString(); %>
                            <% string extension = System.Configuration.ConfigurationManager.AppSettings["extension"].ToString(); %>
                            <a href="<%=siteDirName%>Projects/<%# Eval("id")%>/<%# Eval("ProTitle")%><%=extension%>">
                                <%# Eval("ProName")%></a> </li>
                    </ItemTemplate>
                </asp:Repeater>
            </ul>
            
             <h2>Non Industrial Proejcts:</h2>
            <ul>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Personal %>"
                      SelectCommand="SELECT TOP (3) [id], [ProName],REPLACE(ProName, ' ', '-') AS ProTitle, [ProCaption], [ProContent], [ProTechLang], [ProDatabase], [ProType], [ProTools], [ProURL], [ProCatagory] FROM [Projects] WHERE ([ProCatagory] = @ProCatagory) ORDER BY [ProDisplaySerial]">
                      <SelectParameters>
                          <asp:Parameter DefaultValue="nonind" Name="ProCatagory" Type="String" />
                      </SelectParameters>
                  </asp:SqlDataSource>
                <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource2">
                    <ItemTemplate>
                        <li>
                            <% string siteDirName = System.Configuration.ConfigurationManager.AppSettings["siteDirName"].ToString(); %>
                            <% string extension = System.Configuration.ConfigurationManager.AppSettings["extension"].ToString(); %>
                            <a href="<%=siteDirName%>Projects/<%# Eval("id")%>/<%# Eval("ProTitle")%><%=extension%>">
                                <%# Eval("ProName")%></a> </li>
                    </ItemTemplate>
                </asp:Repeater>
            </ul>
			   </div>
			   </div>

<div class="left_side" style="text-align: justify">

               <hr style=" height:2px; color:GrayText"  /> 
                <span style="font-weight:bold" > [Industrual Projects]</span>
                <hr style=" height:2px; color:GrayText"  />
                
                  <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
                      <ItemTemplate>
                          <h2><a target="_blank" href="<%# Eval("ProURL") %>"><%# Eval("ProName") %></a> </h2>
                          <h3><%# Eval("ProCaption") %><a target="_blank" href="<%# Eval("ProURL") %>"> [<%# Eval("ProURL") %>]</a></h3>
                            <div class="padding" style="text-align: justify">
                                <div class="img"><a target="_blank" href="<%# Eval("ProURL") %>" ><img width="152" height="138" alt='<%# Eval("ProName") %>' title='<%# Eval("ProName") %>'  src="<%=Application["siteDirName"].ToString() %>media/career/<%# Eval("id") %>.png" /></a></div>
                                    <%# Eval("ProContent") %><br /><br/>
                                 <table>
                                    <tr> <td><b>Language/Technologies:</b></td> <td><%# Eval("ProTechLang") %></td> </tr>
                                    <tr> <td> <b>Database:</b></td> <td ><%# Eval("ProDatabase") %> <br/></td> </tr>
                                    <tr> <td><b>Project Type:</b></td> <td><%# Eval("ProType") %></td> </tr>
                                    <tr> <td><b>Tools:</b></td><td><%# Eval("ProTools")%></td> </tr>
                                </table>                     
                          </div>                         
                          <p class="date"></p>
                          <br />
                      </ItemTemplate>
                  </asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Personal %>"
                      
                   SelectCommand="SELECT [id], [ProName], [ProCaption], [ProContent], [ProTechLang], [ProDatabase], [ProType], [ProTools], [ProURL], [ProCatagory] FROM [Projects] WHERE ([ProCatagory] = @ProCatagory) ORDER BY [ProDisplaySerial]" 
                   onselecting="SqlDataSource1_Selecting">
                      <SelectParameters>
                          <asp:Parameter DefaultValue="ind" Name="ProCatagory" Type="String" />
                      </SelectParameters>
                  </asp:SqlDataSource>
                  </div>
</asp:Content>

